USE [Robot]
GO
--insert to parameter
insert into tblParameter values('Customer Name')

--insert to constant
insert into tblconstant values(1,'SME')
insert into tblconstant values(1,'Consumer Transaction Banking')
insert into tblconstant values(1,'Wholesale Banking')

--insert to user
insert into tbluser values('1234567','HTT','asd@fsdf',null,1,1)
insert into tbluser values('7654321','HTT1','asd@fsdf',null,2,1)
--select * from tblopicCode

--insert to opics code
insert into tblopicCode values('Consumer Transaction Banking','100','SCBVNCBHNI','CONS')
insert into tblopicCode values('Consumer Transaction Banking','101','SCBVNCBHNI','CONS')
insert into tblopicCode values('Consumer Transaction Banking','200','SCBVNCBHCM','CONS')
insert into tblopicCode values('SME','100','SCBVNHCM','CSME')
insert into tblopicCode values('SME','101','SCBVNHCM','CSME')
insert into tblopicCode values('SME','200','SCBSMEHCM','CSME')
insert into tblopicCode values('Wholesale Banking','200','SCBPAYHNI','VIET')
insert into tblopicCode values('Wholesale Banking','100','SCBPAYHNI','VIET')
insert into tblopicCode values('Wholesale Banking','101','SCBPAYHNI','VIET')
--Insert to opics currency
insert into tblCurrencyinopics values('AUD','CHF',1);	insert into tblCurrencyinopics values('CHF','AUD',1);
insert into tblCurrencyinopics values('AUD','EUR',1);	insert into tblCurrencyinopics values('EUR','AUD',1);
insert into tblCurrencyinopics values('AUD','GBP',1);	insert into tblCurrencyinopics values('GBP','AUD',1);
insert into tblCurrencyinopics values('AUD','JPY',1);	insert into tblCurrencyinopics values('JPY','AUD',1);
insert into tblCurrencyinopics values('AUD','SGD',1);	insert into tblCurrencyinopics values('SGD','AUD',1);
insert into tblCurrencyinopics values('AUD','USD',1);	insert into tblCurrencyinopics values('USD','AUD',1);
insert into tblCurrencyinopics values('AUD','VND',1);	insert into tblCurrencyinopics values('VND','AUD',1);
insert into tblCurrencyinopics values('CAD','EUR',1);	insert into tblCurrencyinopics values('EUR','CAD',1);
insert into tblCurrencyinopics values('CAD','USD',1);	insert into tblCurrencyinopics values('USD','CAD',1);
insert into tblCurrencyinopics values('CAD','VND',1);	insert into tblCurrencyinopics values('VND','CAD',1);
insert into tblCurrencyinopics values('CHF','EUR',1);	insert into tblCurrencyinopics values('EUR','CHF',1);
insert into tblCurrencyinopics values('CHF','USD',1);	insert into tblCurrencyinopics values('USD','CHF',1);
insert into tblCurrencyinopics values('CHF','VND',1);	insert into tblCurrencyinopics values('VND','CHF',1);
insert into tblCurrencyinopics values('CNY','USD',1);	insert into tblCurrencyinopics values('USD','CNY',1);
insert into tblCurrencyinopics values('CNY','VND',1);	insert into tblCurrencyinopics values('VND','CNY',1);
insert into tblCurrencyinopics values('DKK','EUR',1);	insert into tblCurrencyinopics values('EUR','DKK',1);
insert into tblCurrencyinopics values('DKK','USD',1);	insert into tblCurrencyinopics values('USD','DKK',1);
insert into tblCurrencyinopics values('DKK','VND',1);	insert into tblCurrencyinopics values('VND','DKK',1);
insert into tblCurrencyinopics values('EUR','GBP',1);	insert into tblCurrencyinopics values('GBP','EUR',1);
insert into tblCurrencyinopics values('EUR','HKD',1);	insert into tblCurrencyinopics values('HKD','EUR',1);
insert into tblCurrencyinopics values('AUD','JPY',1);	insert into tblCurrencyinopics values('JPY','EUR',1);
insert into tblCurrencyinopics values('EUR','SGD',1);	insert into tblCurrencyinopics values('SGD','EUR',1);
insert into tblCurrencyinopics values('EUR','THB',1);	insert into tblCurrencyinopics values('THB','EUR',1);
insert into tblCurrencyinopics values('EUR','USD',1);	insert into tblCurrencyinopics values('USD','EUR',1);
insert into tblCurrencyinopics values('EUR','VND',1);	insert into tblCurrencyinopics values('VND','EUR',1);
insert into tblCurrencyinopics values('GBP','JPY',1);	insert into tblCurrencyinopics values('JPY','GBP',1);
insert into tblCurrencyinopics values('GBP','SGD',1);	insert into tblCurrencyinopics values('SGD','GBP',1);
insert into tblCurrencyinopics values('GBP','THB',1);	insert into tblCurrencyinopics values('THB','GBP',1);
insert into tblCurrencyinopics values('GBP','USD',1);	insert into tblCurrencyinopics values('USD','GBP',1);
insert into tblCurrencyinopics values('GBP','VND',1);	insert into tblCurrencyinopics values('VND','GBP',1);
insert into tblCurrencyinopics values('HKD','USD',1);	insert into tblCurrencyinopics values('USD','HKD',1);
insert into tblCurrencyinopics values('HKD','VND',1);	insert into tblCurrencyinopics values('VND','HKD',1);
insert into tblCurrencyinopics values('JPY','SGD',1);	insert into tblCurrencyinopics values('SGD','JPY',1);
insert into tblCurrencyinopics values('JPY','USD',1);	insert into tblCurrencyinopics values('USD','JPY',1);
insert into tblCurrencyinopics values('JPY','VND',1);	insert into tblCurrencyinopics values('VND','JPY',1);
insert into tblCurrencyinopics values('SEK','USD',1);	insert into tblCurrencyinopics values('USD','SEK',1);
insert into tblCurrencyinopics values('SEK','VND',1);	insert into tblCurrencyinopics values('VND','SEK',1);
insert into tblCurrencyinopics values('SGD','USD',1);	insert into tblCurrencyinopics values('USD','SGD',1);
insert into tblCurrencyinopics values('SGD','VND',1);	insert into tblCurrencyinopics values('VND','SGD',1);
insert into tblCurrencyinopics values('THB','USD',1);	insert into tblCurrencyinopics values('USD','THB',1);
insert into tblCurrencyinopics values('THB','VND',1);	insert into tblCurrencyinopics values('VND','THB',1);
insert into tblCurrencyinopics values('USD','VND',1);	insert into tblCurrencyinopics values('VND','USD',1);

